﻿CREATE TABLE [dbo].[Handlers] (
    [ID]               INT             IDENTITY (1, 1) NOT NULL,
    [Name]             VARCHAR (50)    NOT NULL,
    [Enabled]          BIT             NOT NULL,
    [Namespace]        VARCHAR (255)   NOT NULL,
    [HandlerFullName]  VARCHAR (250)   NOT NULL,
    [ContractFullName] VARCHAR (250)   NOT NULL,
    [AssemblyFullName] VARCHAR (250)   NOT NULL,
    [AssemblyData]     VARBINARY (MAX) NOT NULL,
    [Version]          VARCHAR (50)    NULL,
    [Scope]            VARCHAR (50)    NULL,
    [Role]             VARCHAR (100)   NULL
);

